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