UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNdgsuLvG4y9SEmFi1BMtH3658u+DjoKaRSez+dcUiE='
WHERE
key_id = '1ac622af94ef92193dca05b7a9a6bbf177378f7855e3338c8129c564c02fa8e7'
AND (
token = 'nNdgsuLvG4y9SEmFi1BMtH3658u+DjoKaRSez+dcUiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)