UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6O9P8sKI3iLtwfH63DgzYEFwqaVjDIgttd3qsYbdT1o='
WHERE
key_id = '1e40dee2fdca8422f8ce57c1696e6b3b30a0817ee670615ee84a6c29b01948ec'
AND (
token = '6O9P8sKI3iLtwfH63DgzYEFwqaVjDIgttd3qsYbdT1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)