UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLl/he8g/1wRul8Tu12SaGN0UvzKQJuEctwyDl7keyk='
WHERE
key_id = 'f5dbbc69bb1a2d0475437d4fc432e5a1706a3ffaa96a940eb65a5d03ad09f979'
AND (
token = 'pLl/he8g/1wRul8Tu12SaGN0UvzKQJuEctwyDl7keyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)