UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G4K03u4ea3H66twO3UtEcUeLiFGgXsaMg4hI7ruH9io='
WHERE
key_id = 'a9f969dd8a5d9aa3c4086c710f2f4a1a49f3a682708a5dc16a3083d53c8cb3ef'
AND (
token = 'G4K03u4ea3H66twO3UtEcUeLiFGgXsaMg4hI7ruH9io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)