UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N5J1gNwJnjAGwgwN50UWjFEP8jsMPadxGI9FXpMoTYw='
WHERE
key_id = '4bfc51eadbec387fd2d040f96cc88f2f56ca712e90925a31e038f1338f614d46'
AND (
token = 'N5J1gNwJnjAGwgwN50UWjFEP8jsMPadxGI9FXpMoTYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)