UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qPzOVLqw5+3QXT2zfx6G/luXJLzcjqKEuGf7Vaoz3PM='
WHERE
key_id = 'ff38c74adc0f46a6802b9945dbe4adbffa50b3127eae9fa06d5527f7f11801c0'
AND (
token = 'qPzOVLqw5+3QXT2zfx6G/luXJLzcjqKEuGf7Vaoz3PM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)