UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dYI8HiJxCRET9DNEm0z6NHe8aQEK3QjBWI8QWS8tiUg='
WHERE
key_id = '18f6d236791cabb49eccf155846643a4a8c27367a3e7a04295a8466c7ec15a69'
AND (
token = 'dYI8HiJxCRET9DNEm0z6NHe8aQEK3QjBWI8QWS8tiUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)