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