UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KFwrgcL51p6QBeBQJWo9Fa9pLpTv8zFtmHVC8rSuuDM=' 
WHERE 
  key_id = '16b1a49668324a262b2ca25b30fa0f91cc2af1c52208c62c84900dc471c3e1a5' 
  AND (
    token = 'KFwrgcL51p6QBeBQJWo9Fa9pLpTv8zFtmHVC8rSuuDM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047