UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j2zPmi6Oy7AUGBYVdiLlp6uHwpLuvlM1e1SfBtQjZMU='
WHERE
key_id = 'a973b23bb050f96fa0f5e2f29d875d4afb7a5faf2f5af3a497aa950ef97a9506'
AND (
token = 'j2zPmi6Oy7AUGBYVdiLlp6uHwpLuvlM1e1SfBtQjZMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)