UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BbCPd9x5ijJ0WXAS2L5bZzr+CBBEBdhTW7gDLw6RtcM=' 
WHERE 
  key_id = '5fe3610282a6ed7bef9d2e348e23d8987e7bec17bc4b7df1d75721c5a6db7f1c' 
  AND (
    token = 'BbCPd9x5ijJ0WXAS2L5bZzr+CBBEBdhTW7gDLw6RtcM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031