UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YG4qOSe48xJ/7SHfWMY15JXdnFzWJH0a/CVDe0P+4bs='
WHERE
key_id = 'd84f74851d9261f7961de1f5403cee3ceac1beee0bc02b6577d1604e1d3e7150'
AND (
token = 'YG4qOSe48xJ/7SHfWMY15JXdnFzWJH0a/CVDe0P+4bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)