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