UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XABRFGQ3IxRCcPl+HRergamOcpEdx8Y7nSYWHh1KqEc='
WHERE
key_id = '29ed57d969b67578168b1c3618c874d0948fcde6a3a6afc66bba085889896a80'
AND (
token = 'XABRFGQ3IxRCcPl+HRergamOcpEdx8Y7nSYWHh1KqEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)