UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xS3u8FNFqwj2A0VwWyXs+/H44tzKKkBwWBe60mr7BSE='
WHERE
key_id = 'cbb893ef936ea90cb19568acf882ce7681d1945a470450624ea20fd7e58bf2f1'
AND (
token = 'xS3u8FNFqwj2A0VwWyXs+/H44tzKKkBwWBe60mr7BSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)