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