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