UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'caUO8PIKxVOP6cWarlbMqEC4hGSxvOyMrsIV0Se+ctM='
WHERE
key_id = '48e7135eb03a7949e5457a128ee0c0224fa216387e73b3d26e8f9631bf78b410'
AND (
token = 'caUO8PIKxVOP6cWarlbMqEC4hGSxvOyMrsIV0Se+ctM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)