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