UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sElQyfaVYe6iJ13DDiMdpsQKgCONp+f/7zdtERi4kzA='
WHERE
key_id = 'cfc0b2cc3f1dad512d60ec4eb986e22dbe1a86c24694c5ba33cc5df36f0836c9'
AND (
token = 'sElQyfaVYe6iJ13DDiMdpsQKgCONp+f/7zdtERi4kzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)