UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXmz/kJGWHCd/vEtAysLdcXPzlGAxlRzxoImWXajaNo='
WHERE
key_id = '1ed3d51e475c6ebba3ba2ad0bc3541a0be7021c4a48990030e2831ee410d4631'
AND (
token = 'XXmz/kJGWHCd/vEtAysLdcXPzlGAxlRzxoImWXajaNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)