UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ddPCnqj5ExfOq201o5EiD4OcYyIile1jo5yZe1u+/dU='
WHERE
key_id = 'cefa0ae7f98b57422d9661ad3c93bab84fcfcb53ca1647e3d242abe80506c0c7'
AND (
token = 'ddPCnqj5ExfOq201o5EiD4OcYyIile1jo5yZe1u+/dU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)