UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BcUCaVzv7ExQmXbpNLaI0psFCvIE8+ng3+o7OGD0zlw='
WHERE
key_id = 'a428a65139ed6342531117e5c196875d1f2aee06b0d9276330eaca9839b60cf2'
AND (
token = 'BcUCaVzv7ExQmXbpNLaI0psFCvIE8+ng3+o7OGD0zlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)