UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bX8PYj20NXdb/uNun9RHebcV9cZAHjIj/Iq3Vy4be60='
WHERE
key_id = '07d101ae6e081edc473c5eb5bf9d002b0dfd4ef13132a0de4714f31fc25f784f'
AND (
token = 'bX8PYj20NXdb/uNun9RHebcV9cZAHjIj/Iq3Vy4be60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)