UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+LI7cnWcTkLrMm6zzMhVvzg7TGE5BIkprDOEjAVc+Uc='
WHERE
key_id = '40b037bea9a1885b2f1dbecc3c2330bd7e210ee8a015949834ca7e8081b9654a'
AND (
token = '+LI7cnWcTkLrMm6zzMhVvzg7TGE5BIkprDOEjAVc+Uc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)