UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'E+P8iCsOEYuys0vxf+ENS4kha03hmcXQ9JOoL/rtlcE=' 
WHERE 
  key_id = '4bff18fc8b201149c15f514cf272411876769a4af6d11a266598908ec4c829fd' 
  AND (
    token = 'E+P8iCsOEYuys0vxf+ENS4kha03hmcXQ9JOoL/rtlcE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022