UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iDZYR1pb44yalypXUbm4DmWj1DeHNHtfycYSNX+f7s8='
WHERE
key_id = 'd13be7eb314b952e683fa154ebe6f8d558df7d8d6eb15ef29d1fcee9ed333be5'
AND (
token = 'iDZYR1pb44yalypXUbm4DmWj1DeHNHtfycYSNX+f7s8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)