UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i526f9KNTyHXt/33qsQJXpEe6HxeUUZaEQuaTRu82JU='
WHERE
key_id = 'a93f64b6013387ad43793891e4924cc6e57cd8334b8c234ec8e503757a4f1a2b'
AND (
token = 'i526f9KNTyHXt/33qsQJXpEe6HxeUUZaEQuaTRu82JU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)