UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9QtSS8+0AXN0wiwVRigrhU1G7ATGPI1dUMi6e2kZPuU='
WHERE
key_id = '7ee8d777f48049f3135d331ab1f517ec0e91d563faff3950335e954e6e71509f'
AND (
token = '9QtSS8+0AXN0wiwVRigrhU1G7ATGPI1dUMi6e2kZPuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)