UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BifGdHz8c3TEf4tubHSFIkLrs+tRF6oY2ySNwW5Itvg='
WHERE
key_id = 'e19f3991e6c6d995fc0eeacf0bd7435ba183803140bb8ae470cd0f6e34897708'
AND (
token = 'BifGdHz8c3TEf4tubHSFIkLrs+tRF6oY2ySNwW5Itvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)