UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Y777Sg5184OCgIQZK5+Ja5hs0svTsXRBPCaJZ7uCA8='
WHERE
key_id = 'c04868283bad2b970230fd0b953ddd57bf1d7064c5ad7767142cf236e811936d'
AND (
token = '1Y777Sg5184OCgIQZK5+Ja5hs0svTsXRBPCaJZ7uCA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)