UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'noV3HjsKaV3fONBKg2Q4UjNxDmZRsGuOfz/UFixz5Y8='
WHERE
key_id = 'abbf17b08821c1e6c189596aa1b2fc0a0dca22edb2c08a919f06785a6591b967'
AND (
token = 'noV3HjsKaV3fONBKg2Q4UjNxDmZRsGuOfz/UFixz5Y8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)